Re: psqlodbc and SQLFetch after SQLTables gives

At 16:02 +0900 2003/02/10, Hiroshi Inoue wrote:
[...]
>  > Now I have enabled tracing and found where the failure is. Apparently
>>  MSQ uses SQLFetch just after SQLTables to get the table list, this
>  > SQLFetch fails by returning SQL_NO_DATA_FOUND. Here I have two
>>  snippets from the traces of MSQ retrieving tables first using
>>  OpenLink Postgres Lite driver (that succeeds) and then using psqlodbc
>>  (that fails):
>>
>>  1) openlink driver:
>>
>>  iODBC[Microsoft Query]  ThID:A0000DEC  ENTER SQLTables
>>
>>  iODBC[Microsoft Query]  ThID:A0000DEC  EXIT  SQLTables  with return
>>  code 0 (SQL_SUCCESS)
>>
>>  Microsoft Query  ThID:A0000DEC  EXIT  SQLTables  with return code 0
>>  (SQL_SUCCESS)
>>             HSTMT         0x01619a00
>>             CHAR*         00000000 "..."
>>             SMALLINT      -3536
>>             CHAR*         00000000 "..."
>>             SMALLINT      -18992
>>             CHAR*         00000000 "..."
>>             SMALLINT      15056
>>             CHAR*         0x001c3fd8 "Table"
>
>Hmm, if it is "TABLE", it seems to work.
>OK I would change the driver to be insenitive about
>it.
>

Hi Hiroshi, sorry but I do not understand. In both cases (the working
one and the not working one) it is "Table". What seems to change is
the way the client application retrieves the data.  I have now enable
debug and repeated the test, may I send you the output?

Where would I change the source anyway? In info.c?

Thanks for helping me solve this.

Giuliano